package com.monitor.dao;

import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.monitor.entity.ErpBidataList;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author LX
 * @since 2018-09-12
 */
public interface ErpBidataListMapper extends BaseMapper<ErpBidataList> {
	@Select("select * from erp_bidata_list bl where bl.bi_id=#{biId}")
	public List<ErpBidataList> selectByBiId(@Param("biId")int biId);
	
	@Select("SELECT * FROM erp_bidata_list WHERE bi_id=#{biId} AND parameter_name=#{name} LIMIT 0,1")
	public ErpBidataList selectByBiIdAndName(@Param("biId")int biId,@Param("name")String name);
}
